Forum Discussion

Johan_de_Rooij's avatar
Johan_de_Rooij
Copper Contributor
Oct 03, 2019

How can I import tasks in Microsoft To Do ? (urgent)

I have to import a large number of tasks from TodoIst (or CSV)

  • tmac2k's avatar
    tmac2k
    Copper Contributor
    If you're on Windows, and you can get your tasks into Excel, and if you just care about the task names and not attachments, you can just copy a column full of tasks in Excel, and paste them into the To Do desktop app and it will create all your tasks at once (as separate items as expected).
    • hellololly's avatar
      hellololly
      Copper Contributor

      Thanks this was BRILLIANT! This also works if you use Microsoft To Do via a browser (rather than Windows desktop app_, which was a god send as I'm on a Mac, and the Mac app doesn't create the items when pasting from a table.

    • cerebro84's avatar
      cerebro84
      Copper Contributor

      tmac2kBrilliant! I just tried it on Ubuntu with a free Office alternative Calc and To Do on Firefox and works as well!

  • BenR00002145's avatar
    BenR00002145
    Brass Contributor
    I just flipped on the "coming soon" features of the MS Outlook desktop app and restarted. This is Summer of 2021, it might require enrolling in insider for office for those interested.

    It looks like To Do is now much more integrated into Outlook. A simple copy-paste and my data is in. I would expect import options to be smoother as well.
  • Johan_de_Rooij 

    I’ve solved it!

    I’ve long had a frustration with the fact that MS To-do does not have the ability to import mass tasks from excel like Wunderlist did, and every attempt to search up a solution just led me to posts with the same complaint, and no solution. However, there is a way to do it – through Outlook instead.

    To do this, you must be signed in to Outlook on a desktop – as far as I know this will not work on the web version. On the bottom left there is a tab to navigate to the “Tasks” page – click on this. If you are signed in to the correct MS account, your To-do list should be synced to this page. Find the list you want to upload to, and make sure there is at least one filler task in their for the time being so that you have a template to work from. Then, go to file > Open and export > Import/Export > Export to a file > Comma Separated Values > select your desired folder/list > save the file. Then you can go in and open that file, and add your tasks according to the template that was downloaded. Remember to save this as a CSV!

    After you have edited and saved your CSV, go to file > Open and export > Import/Export > Import from another program or file > Comma Separated Values > Select your file > select your desired folder/list > **Check that the box is clicked** > import your tasks!

    **if the box is not clicked, click it, and it will (Likely) bring you to a page to “map custom fields”. Don’t just skip past this, if it is showing up it probably means that something about your template got a little messed up and its not quite sure what to import, and to where. Verify that every category on the right-hand “to” column has the correct column header connected to it, and if not, fix it by dragging and dropping from the left hand column.

     

    NOTE: I am not a MS expert! I just found a solution that works, and this is the sequence of events that got me there. Hopefully it works for you!

    • Baldingowl80's avatar
      Baldingowl80
      Copper Contributor
      Hi Sofia. Is there any way you can add pictures to this description. Having trouble following along with this one. Any help would be greatly appreciated, thanks in advance.
    • odbod2485's avatar
      odbod2485
      Copper Contributor
      As someone completing a Gmail (personal accounts) to office 365 migration this works brilliantly. As a note to others you can export google tasks using google takeout, this exports as a JSON which you can then use a convertor tool (JSON to CSV) to convert the file and import as mentioned above.


    • BenR00002145's avatar
      BenR00002145
      Brass Contributor
      Thank you for sharing this.
      Fun fact: To Do data is synced with Outlook Tasks (web app and desktop app).
      To Do is synced with Outlook Project Moca (renamed to

      MS Sticky Notes is linked to One Note.
      MS Sticky Notes is linked to Outlook (only confirmed with web app outlook)

      I don't use Outlook with My MS Account, so my Tasks List only showed items from my Gmail, not To Do. Before I solved that, I went to the Outlook Web app.

      When I went to the "To Do" part of the Outlook web app, I was able to paste a list of items separated by new lines, and the web app version of To Do just accepted the pasted list.
  • Lewis-H's avatar
    Lewis-H
    Iron Contributor

    Johan_de_Rooij 

    Import your Wunderlist account to Microsoft To Do
    1. Head to Settings and select Import.
    2. Sign in to your Wunderlist account.
    3. Once you've signed in, we'll show you the number of lists and tasks that will be imported from your Wunderlist account to Microsoft To Do. ...
    4. Select Import begin moving your lists and tasks over from Wunderlist to Microsoft To Do.
    • Jim_1314's avatar
      Jim_1314
      Copper Contributor

      Lewis-H Please forgive my ignorance to your previous responses. Can you tell me how to import my Omnifocus tasks into Microsoft To-Do?

  • You can do this with Flow, but only for yourself, there is no bulk import tool that can do this. But there is a Create to-do flow action that you can loop through from a CSV file that you feed to the flow via OneDrive.

Resources